{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "\n",
    "# track.csv contains the origination information for each track(artist, album year of release, genre catagories,etc)\n",
    "# genres.csv is a genre-look up table,\n",
    "# features.csv and echonest.csv are two sets of extracted audio features generated through the Librosa,\n",
    "# and Echonest libraries, with each song labeled by it's track id."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "ename": "FileNotFoundError",
     "evalue": "File b'tracks.csv' does not exist",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mFileNotFoundError\u001b[0m                         Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-3-65b17727971c>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mtracks\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'tracks.csv'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      2\u001b[0m \u001b[0mgenres\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'genres.csv'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      3\u001b[0m \u001b[0mfeatures\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'features.csv'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      4\u001b[0m \u001b[0mechonest\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'echonest.csv'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\AppData\\Local\\Programs\\Python\\Python36\\lib\\site-packages\\pandas\\io\\parsers.py\u001b[0m in \u001b[0;36mparser_f\u001b[1;34m(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, escapechar, comment, encoding, dialect, tupleize_cols, error_bad_lines, warn_bad_lines, skipfooter, skip_footer, doublequote, delim_whitespace, as_recarray, compact_ints, use_unsigned, low_memory, buffer_lines, memory_map, float_precision)\u001b[0m\n\u001b[0;32m    653\u001b[0m                     skip_blank_lines=skip_blank_lines)\n\u001b[0;32m    654\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 655\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    656\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    657\u001b[0m     \u001b[0mparser_f\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m__name__\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mname\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\AppData\\Local\\Programs\\Python\\Python36\\lib\\site-packages\\pandas\\io\\parsers.py\u001b[0m in \u001b[0;36m_read\u001b[1;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[0;32m    403\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    404\u001b[0m     \u001b[1;31m# Create the parser.\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 405\u001b[1;33m     \u001b[0mparser\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mTextFileReader\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    406\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    407\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[0mchunksize\u001b[0m \u001b[1;32mor\u001b[0m \u001b[0miterator\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\AppData\\Local\\Programs\\Python\\Python36\\lib\\site-packages\\pandas\\io\\parsers.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, f, engine, **kwds)\u001b[0m\n\u001b[0;32m    760\u001b[0m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0moptions\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'has_index_names'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mkwds\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'has_index_names'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    761\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 762\u001b[1;33m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_make_engine\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mengine\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    763\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    764\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mclose\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\AppData\\Local\\Programs\\Python\\Python36\\lib\\site-packages\\pandas\\io\\parsers.py\u001b[0m in \u001b[0;36m_make_engine\u001b[1;34m(self, engine)\u001b[0m\n\u001b[0;32m    964\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m_make_engine\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mengine\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'c'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    965\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mengine\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m'c'\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 966\u001b[1;33m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_engine\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mCParserWrapper\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mf\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0moptions\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    967\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    968\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mengine\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;34m'python'\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\AppData\\Local\\Programs\\Python\\Python36\\lib\\site-packages\\pandas\\io\\parsers.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, src, **kwds)\u001b[0m\n\u001b[0;32m   1580\u001b[0m         \u001b[0mkwds\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'allow_leading_cols'\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mindex_col\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32mFalse\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1581\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1582\u001b[1;33m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_reader\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mparsers\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mTextReader\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0msrc\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwds\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   1583\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1584\u001b[0m         \u001b[1;31m# XXX\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader.__cinit__ (pandas\\_libs\\parsers.c:4209)\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader._setup_parser_source (pandas\\_libs\\parsers.c:8873)\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;31mFileNotFoundError\u001b[0m: File b'tracks.csv' does not exist"
     ],
     "output_type": "error"
    }
   ],
   "source": [
    "tracks = pd.read_csv('tracks.csv')\n",
    "genres = pd.read_csv('genres.csv')\n",
    "features = pd.read_csv('features.csv')\n",
    "echonest = pd.read_csv('echonest.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'tracks' is not defined",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-1-539371acc817>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[1;31m#tracks\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0mtracks\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'tracks' is not defined"
     ],
     "output_type": "error"
    }
   ],
   "source": [
    "#tracks\n",
    "tracks.columns\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>album</th>\n",
       "      <th>album.1</th>\n",
       "      <th>album.2</th>\n",
       "      <th>album.3</th>\n",
       "      <th>album.4</th>\n",
       "      <th>album.5</th>\n",
       "      <th>album.6</th>\n",
       "      <th>album.7</th>\n",
       "      <th>album.8</th>\n",
       "      <th>...</th>\n",
       "      <th>track.10</th>\n",
       "      <th>track.11</th>\n",
       "      <th>track.12</th>\n",
       "      <th>track.13</th>\n",
       "      <th>track.14</th>\n",
       "      <th>track.15</th>\n",
       "      <th>track.16</th>\n",
       "      <th>track.17</th>\n",
       "      <th>track.18</th>\n",
       "      <th>track.19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>comments</td>\n",
       "      <td>date_created</td>\n",
       "      <td>date_released</td>\n",
       "      <td>engineer</td>\n",
       "      <td>favorites</td>\n",
       "      <td>id</td>\n",
       "      <td>information</td>\n",
       "      <td>listens</td>\n",
       "      <td>producer</td>\n",
       "      <td>...</td>\n",
       "      <td>information</td>\n",
       "      <td>interest</td>\n",
       "      <td>language_code</td>\n",
       "      <td>license</td>\n",
       "      <td>listens</td>\n",
       "      <td>lyricist</td>\n",
       "      <td>number</td>\n",
       "      <td>publisher</td>\n",
       "      <td>tags</td>\n",
       "      <td>title</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>track_id</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2008-11-26 01:44:45</td>\n",
       "      <td>2009-01-05 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>&lt;p&gt;&lt;/p&gt;</td>\n",
       "      <td>6073</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4656</td>\n",
       "      <td>en</td>\n",
       "      <td>Attribution-NonCommercial-ShareAlike 3.0 Inter...</td>\n",
       "      <td>1293</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>Food</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>2008-11-26 01:44:45</td>\n",
       "      <td>2009-01-05 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>&lt;p&gt;&lt;/p&gt;</td>\n",
       "      <td>6073</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1470</td>\n",
       "      <td>en</td>\n",
       "      <td>Attribution-NonCommercial-ShareAlike 3.0 Inter...</td>\n",
       "      <td>514</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>Electric Ave</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2008-11-26 01:44:45</td>\n",
       "      <td>2009-01-05 00:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>&lt;p&gt;&lt;/p&gt;</td>\n",
       "      <td>6073</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1933</td>\n",
       "      <td>en</td>\n",
       "      <td>Attribution-NonCommercial-ShareAlike 3.0 Inter...</td>\n",
       "      <td>1151</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>This World</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 53 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Unnamed: 0     album              album.1              album.2   album.3  \\\n",
       "0        NaN  comments         date_created        date_released  engineer   \n",
       "1   track_id       NaN                  NaN                  NaN       NaN   \n",
       "2          2         0  2008-11-26 01:44:45  2009-01-05 00:00:00       NaN   \n",
       "3          3         0  2008-11-26 01:44:45  2009-01-05 00:00:00       NaN   \n",
       "4          5         0  2008-11-26 01:44:45  2009-01-05 00:00:00       NaN   \n",
       "\n",
       "     album.4 album.5      album.6  album.7   album.8      ...       \\\n",
       "0  favorites      id  information  listens  producer      ...        \n",
       "1        NaN     NaN          NaN      NaN       NaN      ...        \n",
       "2          4       1      <p></p>     6073       NaN      ...        \n",
       "3          4       1      <p></p>     6073       NaN      ...        \n",
       "4          4       1      <p></p>     6073       NaN      ...        \n",
       "\n",
       "      track.10  track.11       track.12  \\\n",
       "0  information  interest  language_code   \n",
       "1          NaN       NaN            NaN   \n",
       "2          NaN      4656             en   \n",
       "3          NaN      1470             en   \n",
       "4          NaN      1933             en   \n",
       "\n",
       "                                            track.13 track.14  track.15  \\\n",
       "0                                            license  listens  lyricist   \n",
       "1                                                NaN      NaN       NaN   \n",
       "2  Attribution-NonCommercial-ShareAlike 3.0 Inter...     1293       NaN   \n",
       "3  Attribution-NonCommercial-ShareAlike 3.0 Inter...      514       NaN   \n",
       "4  Attribution-NonCommercial-ShareAlike 3.0 Inter...     1151       NaN   \n",
       "\n",
       "  track.16   track.17 track.18      track.19  \n",
       "0   number  publisher     tags         title  \n",
       "1      NaN        NaN      NaN           NaN  \n",
       "2        3        NaN       []          Food  \n",
       "3        4        NaN       []  Electric Ave  \n",
       "4        6        NaN       []    This World  \n",
       "\n",
       "[5 rows x 53 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "tracks.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 106576 entries, 0 to 106575\n",
      "Data columns (total 53 columns):\n",
      "Unnamed: 0    106575 non-null object\n",
      "album         106575 non-null object\n",
      "album.1       103046 non-null object\n",
      "album.2       70295 non-null object\n",
      "album.3       15297 non-null object\n",
      "album.4       106575 non-null object\n",
      "album.5       106575 non-null object\n",
      "album.6       83150 non-null object\n",
      "album.7       106575 non-null object\n",
      "album.8       18061 non-null object\n",
      "album.9       106575 non-null object\n",
      "album.10      105550 non-null object\n",
      "album.11      106575 non-null object\n",
      "album.12      100067 non-null object\n",
      "artist        22712 non-null object\n",
      "artist.1      5376 non-null object\n",
      "artist.2      14272 non-null object\n",
      "artist.3      71157 non-null object\n",
      "artist.4      106575 non-null object\n",
      "artist.5      105719 non-null object\n",
      "artist.6      106575 non-null object\n",
      "artist.7      106575 non-null object\n",
      "artist.8      44545 non-null object\n",
      "artist.9      70211 non-null object\n",
      "artist.10     44545 non-null object\n",
      "artist.11     46850 non-null object\n",
      "artist.12     106575 non-null object\n",
      "artist.13     13153 non-null object\n",
      "artist.14     106575 non-null object\n",
      "artist.15     79262 non-null object\n",
      "artist.16     5582 non-null object\n",
      "set           106575 non-null object\n",
      "set.1         106575 non-null object\n",
      "track         106575 non-null object\n",
      "track.1       106575 non-null object\n",
      "track.2       3836 non-null object\n",
      "track.3       106575 non-null object\n",
      "track.4       6160 non-null object\n",
      "track.5       106575 non-null object\n",
      "track.6       106575 non-null object\n",
      "track.7       49599 non-null object\n",
      "track.8       106575 non-null object\n",
      "track.9       106575 non-null object\n",
      "track.10      2510 non-null object\n",
      "track.11      106575 non-null object\n",
      "track.12      15025 non-null object\n",
      "track.13      106488 non-null object\n",
      "track.14      106575 non-null object\n",
      "track.15      482 non-null object\n",
      "track.16      106575 non-null object\n",
      "track.17      1435 non-null object\n",
      "track.18      106575 non-null object\n",
      "track.19      106574 non-null object\n",
      "dtypes: object(53)\n",
      "memory usage: 43.1+ MB\n"
     ]
    }
   ],
   "source": [
    "\n",
    "tracks.info()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'tracks' is not defined",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-1-0048453cc73e>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mtracks\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mdescribe\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0minclude\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'all'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'tracks' is not defined"
     ],
     "output_type": "error"
    }
   ],
   "source": [
    "tracks.describe(include='all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'genres' is not defined",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-2-981e8d413439>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[1;31m#genres\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0mgenres\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m: name 'genres' is not defined"
     ],
     "output_type": "error"
    }
   ],
   "source": [
    "#genres\n",
    "genres.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>genre_id</th>\n",
       "      <th>#tracks</th>\n",
       "      <th>parent</th>\n",
       "      <th>title</th>\n",
       "      <th>top_level</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>8693</td>\n",
       "      <td>38</td>\n",
       "      <td>Avant-Garde</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>5271</td>\n",
       "      <td>0</td>\n",
       "      <td>International</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>1752</td>\n",
       "      <td>0</td>\n",
       "      <td>Blues</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>4126</td>\n",
       "      <td>0</td>\n",
       "      <td>Jazz</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>4106</td>\n",
       "      <td>0</td>\n",
       "      <td>Classical</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   genre_id  #tracks  parent          title  top_level\n",
       "0         1     8693      38    Avant-Garde         38\n",
       "1         2     5271       0  International          2\n",
       "2         3     1752       0          Blues          3\n",
       "3         4     4126       0           Jazz          4\n",
       "4         5     4106       0      Classical          5"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genres.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 163 entries, 0 to 162\n",
      "Data columns (total 5 columns):\n",
      "genre_id     163 non-null int64\n",
      "#tracks      163 non-null int64\n",
      "parent       163 non-null int64\n",
      "title        163 non-null object\n",
      "top_level    163 non-null int64\n",
      "dtypes: int64(4), object(1)\n",
      "memory usage: 6.4+ KB\n"
     ]
    }
   ],
   "source": [
    "genres.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "genre_id     0\n",
       "#tracks      0\n",
       "parent       0\n",
       "title        0\n",
       "top_level    0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genres.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>genre_id</th>\n",
       "      <th>#tracks</th>\n",
       "      <th>parent</th>\n",
       "      <th>title</th>\n",
       "      <th>top_level</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>163.000000</td>\n",
       "      <td>163.000000</td>\n",
       "      <td>163.000000</td>\n",
       "      <td>163</td>\n",
       "      <td>163.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>163</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Loud-Rock</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>254.116564</td>\n",
       "      <td>2142.085890</td>\n",
       "      <td>60.447853</td>\n",
       "      <td>NaN</td>\n",
       "      <td>51.374233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>265.048642</td>\n",
       "      <td>5199.542574</td>\n",
       "      <td>185.396011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>211.470836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>60.500000</td>\n",
       "      <td>125.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>172.000000</td>\n",
       "      <td>563.000000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>400.500000</td>\n",
       "      <td>1846.500000</td>\n",
       "      <td>38.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1235.000000</td>\n",
       "      <td>38154.000000</td>\n",
       "      <td>1235.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1235.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           genre_id       #tracks       parent      title    top_level\n",
       "count    163.000000    163.000000   163.000000        163   163.000000\n",
       "unique          NaN           NaN          NaN        163          NaN\n",
       "top             NaN           NaN          NaN  Loud-Rock          NaN\n",
       "freq            NaN           NaN          NaN          1          NaN\n",
       "mean     254.116564   2142.085890    60.447853        NaN    51.374233\n",
       "std      265.048642   5199.542574   185.396011        NaN   211.470836\n",
       "min        1.000000      0.000000     0.000000        NaN     2.000000\n",
       "25%       60.500000    125.000000     5.000000        NaN     5.000000\n",
       "50%      172.000000    563.000000    15.000000        NaN    12.000000\n",
       "75%      400.500000   1846.500000    38.000000        NaN    20.000000\n",
       "max     1235.000000  38154.000000  1235.000000        NaN  1235.000000"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "genres.describe(include='all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['feature', 'chroma_cens', 'chroma_cens.1', 'chroma_cens.2',\n",
       "       'chroma_cens.3', 'chroma_cens.4', 'chroma_cens.5', 'chroma_cens.6',\n",
       "       'chroma_cens.7', 'chroma_cens.8',\n",
       "       ...\n",
       "       'tonnetz.39', 'tonnetz.40', 'tonnetz.41', 'zcr', 'zcr.1', 'zcr.2',\n",
       "       'zcr.3', 'zcr.4', 'zcr.5', 'zcr.6'],\n",
       "      dtype='object', length=519)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#features\n",
    "features.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>feature</th>\n",
       "      <th>chroma_cens</th>\n",
       "      <th>chroma_cens.1</th>\n",
       "      <th>chroma_cens.2</th>\n",
       "      <th>chroma_cens.3</th>\n",
       "      <th>chroma_cens.4</th>\n",
       "      <th>chroma_cens.5</th>\n",
       "      <th>chroma_cens.6</th>\n",
       "      <th>chroma_cens.7</th>\n",
       "      <th>chroma_cens.8</th>\n",
       "      <th>...</th>\n",
       "      <th>tonnetz.39</th>\n",
       "      <th>tonnetz.40</th>\n",
       "      <th>tonnetz.41</th>\n",
       "      <th>zcr</th>\n",
       "      <th>zcr.1</th>\n",
       "      <th>zcr.2</th>\n",
       "      <th>zcr.3</th>\n",
       "      <th>zcr.4</th>\n",
       "      <th>zcr.5</th>\n",
       "      <th>zcr.6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>statistics</td>\n",
       "      <td>kurtosis</td>\n",
       "      <td>kurtosis</td>\n",
       "      <td>kurtosis</td>\n",
       "      <td>kurtosis</td>\n",
       "      <td>kurtosis</td>\n",
       "      <td>kurtosis</td>\n",
       "      <td>kurtosis</td>\n",
       "      <td>kurtosis</td>\n",
       "      <td>kurtosis</td>\n",
       "      <td>...</td>\n",
       "      <td>std</td>\n",
       "      <td>std</td>\n",
       "      <td>std</td>\n",
       "      <td>kurtosis</td>\n",
       "      <td>max</td>\n",
       "      <td>mean</td>\n",
       "      <td>median</td>\n",
       "      <td>min</td>\n",
       "      <td>skew</td>\n",
       "      <td>std</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>number</td>\n",
       "      <td>01</td>\n",
       "      <td>02</td>\n",
       "      <td>03</td>\n",
       "      <td>04</td>\n",
       "      <td>05</td>\n",
       "      <td>06</td>\n",
       "      <td>07</td>\n",
       "      <td>08</td>\n",
       "      <td>09</td>\n",
       "      <td>...</td>\n",
       "      <td>04</td>\n",
       "      <td>05</td>\n",
       "      <td>06</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "      <td>01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>track_id</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>7.1806526184e+00</td>\n",
       "      <td>5.2303090096e+00</td>\n",
       "      <td>2.4932080507e-01</td>\n",
       "      <td>1.3476201296e+00</td>\n",
       "      <td>1.4824777842e+00</td>\n",
       "      <td>5.3137123585e-01</td>\n",
       "      <td>1.4815930128e+00</td>\n",
       "      <td>2.6914546490e+00</td>\n",
       "      <td>8.6686819792e-01</td>\n",
       "      <td>...</td>\n",
       "      <td>5.4125156254e-02</td>\n",
       "      <td>1.2225749902e-02</td>\n",
       "      <td>1.2110591866e-02</td>\n",
       "      <td>5.7588901520e+00</td>\n",
       "      <td>4.5947265625e-01</td>\n",
       "      <td>8.5629448295e-02</td>\n",
       "      <td>7.1289062500e-02</td>\n",
       "      <td>0.0000000000e+00</td>\n",
       "      <td>2.0898721218e+00</td>\n",
       "      <td>6.1448108405e-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>1.8889633417e+00</td>\n",
       "      <td>7.6053929329e-01</td>\n",
       "      <td>3.4529656172e-01</td>\n",
       "      <td>2.2952005863e+00</td>\n",
       "      <td>1.6540306807e+00</td>\n",
       "      <td>6.7592434585e-02</td>\n",
       "      <td>1.3668476343e+00</td>\n",
       "      <td>1.0540937185e+00</td>\n",
       "      <td>1.0810308903e-01</td>\n",
       "      <td>...</td>\n",
       "      <td>6.3831120729e-02</td>\n",
       "      <td>1.4211839065e-02</td>\n",
       "      <td>1.7740072682e-02</td>\n",
       "      <td>2.8246941566e+00</td>\n",
       "      <td>4.6630859375e-01</td>\n",
       "      <td>8.4578499198e-02</td>\n",
       "      <td>6.3964843750e-02</td>\n",
       "      <td>0.0000000000e+00</td>\n",
       "      <td>1.7167237997e+00</td>\n",
       "      <td>6.9330163300e-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>5.2756297588e-01</td>\n",
       "      <td>-7.7654317021e-02</td>\n",
       "      <td>-2.7961030602e-01</td>\n",
       "      <td>6.8588310480e-01</td>\n",
       "      <td>1.9375696182e+00</td>\n",
       "      <td>8.8083887100e-01</td>\n",
       "      <td>-9.2319184542e-01</td>\n",
       "      <td>-9.2723226547e-01</td>\n",
       "      <td>6.6661673784e-01</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0730185807e-02</td>\n",
       "      <td>1.2690781616e-02</td>\n",
       "      <td>1.4759079553e-02</td>\n",
       "      <td>6.8084154129e+00</td>\n",
       "      <td>3.7500000000e-01</td>\n",
       "      <td>5.3114086390e-02</td>\n",
       "      <td>4.1503906250e-02</td>\n",
       "      <td>0.0000000000e+00</td>\n",
       "      <td>2.1933031082e+00</td>\n",
       "      <td>4.4860601425e-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>10</td>\n",
       "      <td>3.7022454739e+00</td>\n",
       "      <td>-2.9119303823e-01</td>\n",
       "      <td>2.1967420578e+00</td>\n",
       "      <td>-2.3444947600e-01</td>\n",
       "      <td>1.3673638105e+00</td>\n",
       "      <td>9.9841135740e-01</td>\n",
       "      <td>1.7706941366e+00</td>\n",
       "      <td>1.6045658588e+00</td>\n",
       "      <td>5.2121698856e-01</td>\n",
       "      <td>...</td>\n",
       "      <td>7.4357867241e-02</td>\n",
       "      <td>1.7951935530e-02</td>\n",
       "      <td>1.3921394013e-02</td>\n",
       "      <td>2.1434211731e+01</td>\n",
       "      <td>4.5214843750e-01</td>\n",
       "      <td>7.7514506876e-02</td>\n",
       "      <td>7.1777343750e-02</td>\n",
       "      <td>0.0000000000e+00</td>\n",
       "      <td>3.5423245430e+00</td>\n",
       "      <td>4.0800448507e-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>20</td>\n",
       "      <td>-1.9383698702e-01</td>\n",
       "      <td>-1.9852678478e-01</td>\n",
       "      <td>2.0154602826e-01</td>\n",
       "      <td>2.5855624676e-01</td>\n",
       "      <td>7.7520370483e-01</td>\n",
       "      <td>8.4794059396e-02</td>\n",
       "      <td>-2.8929358721e-01</td>\n",
       "      <td>-8.1641042233e-01</td>\n",
       "      <td>4.3850939721e-02</td>\n",
       "      <td>...</td>\n",
       "      <td>9.5002755523e-02</td>\n",
       "      <td>2.2492416203e-02</td>\n",
       "      <td>2.1355332807e-02</td>\n",
       "      <td>1.6669036865e+01</td>\n",
       "      <td>4.6972656250e-01</td>\n",
       "      <td>4.7224905342e-02</td>\n",
       "      <td>4.0039062500e-02</td>\n",
       "      <td>9.7656250000e-04</td>\n",
       "      <td>3.1898307800e+00</td>\n",
       "      <td>3.0992921442e-02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 519 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      feature        chroma_cens      chroma_cens.1      chroma_cens.2  \\\n",
       "0  statistics           kurtosis           kurtosis           kurtosis   \n",
       "1      number                 01                 02                 03   \n",
       "2    track_id                NaN                NaN                NaN   \n",
       "3           2   7.1806526184e+00   5.2303090096e+00   2.4932080507e-01   \n",
       "4           3   1.8889633417e+00   7.6053929329e-01   3.4529656172e-01   \n",
       "5           5   5.2756297588e-01  -7.7654317021e-02  -2.7961030602e-01   \n",
       "6          10   3.7022454739e+00  -2.9119303823e-01   2.1967420578e+00   \n",
       "7          20  -1.9383698702e-01  -1.9852678478e-01   2.0154602826e-01   \n",
       "\n",
       "       chroma_cens.3     chroma_cens.4     chroma_cens.5      chroma_cens.6  \\\n",
       "0           kurtosis          kurtosis          kurtosis           kurtosis   \n",
       "1                 04                05                06                 07   \n",
       "2                NaN               NaN               NaN                NaN   \n",
       "3   1.3476201296e+00  1.4824777842e+00  5.3137123585e-01   1.4815930128e+00   \n",
       "4   2.2952005863e+00  1.6540306807e+00  6.7592434585e-02   1.3668476343e+00   \n",
       "5   6.8588310480e-01  1.9375696182e+00  8.8083887100e-01  -9.2319184542e-01   \n",
       "6  -2.3444947600e-01  1.3673638105e+00  9.9841135740e-01   1.7706941366e+00   \n",
       "7   2.5855624676e-01  7.7520370483e-01  8.4794059396e-02  -2.8929358721e-01   \n",
       "\n",
       "       chroma_cens.7     chroma_cens.8        ...               tonnetz.39  \\\n",
       "0           kurtosis          kurtosis        ...                      std   \n",
       "1                 08                09        ...                       04   \n",
       "2                NaN               NaN        ...                      NaN   \n",
       "3   2.6914546490e+00  8.6686819792e-01        ...         5.4125156254e-02   \n",
       "4   1.0540937185e+00  1.0810308903e-01        ...         6.3831120729e-02   \n",
       "5  -9.2723226547e-01  6.6661673784e-01        ...         4.0730185807e-02   \n",
       "6   1.6045658588e+00  5.2121698856e-01        ...         7.4357867241e-02   \n",
       "7  -8.1641042233e-01  4.3850939721e-02        ...         9.5002755523e-02   \n",
       "\n",
       "         tonnetz.40        tonnetz.41               zcr             zcr.1  \\\n",
       "0               std               std          kurtosis               max   \n",
       "1                05                06                01                01   \n",
       "2               NaN               NaN               NaN               NaN   \n",
       "3  1.2225749902e-02  1.2110591866e-02  5.7588901520e+00  4.5947265625e-01   \n",
       "4  1.4211839065e-02  1.7740072682e-02  2.8246941566e+00  4.6630859375e-01   \n",
       "5  1.2690781616e-02  1.4759079553e-02  6.8084154129e+00  3.7500000000e-01   \n",
       "6  1.7951935530e-02  1.3921394013e-02  2.1434211731e+01  4.5214843750e-01   \n",
       "7  2.2492416203e-02  2.1355332807e-02  1.6669036865e+01  4.6972656250e-01   \n",
       "\n",
       "              zcr.2             zcr.3             zcr.4             zcr.5  \\\n",
       "0              mean            median               min              skew   \n",
       "1                01                01                01                01   \n",
       "2               NaN               NaN               NaN               NaN   \n",
       "3  8.5629448295e-02  7.1289062500e-02  0.0000000000e+00  2.0898721218e+00   \n",
       "4  8.4578499198e-02  6.3964843750e-02  0.0000000000e+00  1.7167237997e+00   \n",
       "5  5.3114086390e-02  4.1503906250e-02  0.0000000000e+00  2.1933031082e+00   \n",
       "6  7.7514506876e-02  7.1777343750e-02  0.0000000000e+00  3.5423245430e+00   \n",
       "7  4.7224905342e-02  4.0039062500e-02  9.7656250000e-04  3.1898307800e+00   \n",
       "\n",
       "              zcr.6  \n",
       "0               std  \n",
       "1                01  \n",
       "2               NaN  \n",
       "3  6.1448108405e-02  \n",
       "4  6.9330163300e-02  \n",
       "5  4.4860601425e-02  \n",
       "6  4.0800448507e-02  \n",
       "7  3.0992921442e-02  \n",
       "\n",
       "[8 rows x 519 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "features.head(8)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 106577 entries, 0 to 106576\n",
      "Columns: 519 entries, feature to zcr.6\n",
      "dtypes: object(519)\n",
      "memory usage: 422.0+ MB\n"
     ]
    }
   ],
   "source": [
    "features.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>feature</th>\n",
       "      <th>chroma_cens</th>\n",
       "      <th>chroma_cens.1</th>\n",
       "      <th>chroma_cens.2</th>\n",
       "      <th>chroma_cens.3</th>\n",
       "      <th>chroma_cens.4</th>\n",
       "      <th>chroma_cens.5</th>\n",
       "      <th>chroma_cens.6</th>\n",
       "      <th>chroma_cens.7</th>\n",
       "      <th>chroma_cens.8</th>\n",
       "      <th>...</th>\n",
       "      <th>tonnetz.39</th>\n",
       "      <th>tonnetz.40</th>\n",
       "      <th>tonnetz.41</th>\n",
       "      <th>zcr</th>\n",
       "      <th>zcr.1</th>\n",
       "      <th>zcr.2</th>\n",
       "      <th>zcr.3</th>\n",
       "      <th>zcr.4</th>\n",
       "      <th>zcr.5</th>\n",
       "      <th>zcr.6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>106577</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.0000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.00000</td>\n",
       "      <td>...</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.0</td>\n",
       "      <td>106576.000000</td>\n",
       "      <td>106576.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>106577</td>\n",
       "      <td>104376.000000</td>\n",
       "      <td>104381.0000</td>\n",
       "      <td>104389.000000</td>\n",
       "      <td>104394.000000</td>\n",
       "      <td>104409.000000</td>\n",
       "      <td>104378.000000</td>\n",
       "      <td>104389.000000</td>\n",
       "      <td>104383.000000</td>\n",
       "      <td>104374.00000</td>\n",
       "      <td>...</td>\n",
       "      <td>104170.000000</td>\n",
       "      <td>103962.000000</td>\n",
       "      <td>103954.000000</td>\n",
       "      <td>104379.000000</td>\n",
       "      <td>2583.000000</td>\n",
       "      <td>104218.000000</td>\n",
       "      <td>1153.000000</td>\n",
       "      <td>214.0</td>\n",
       "      <td>104320.000000</td>\n",
       "      <td>104272.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>114901</td>\n",
       "      <td>2.120035</td>\n",
       "      <td>-0.1481</td>\n",
       "      <td>0.687363</td>\n",
       "      <td>1.388522</td>\n",
       "      <td>-0.779828</td>\n",
       "      <td>-1.049356</td>\n",
       "      <td>-1.352663</td>\n",
       "      <td>-1.146229</td>\n",
       "      <td>0.13384</td>\n",
       "      <td>...</td>\n",
       "      <td>0.115733</td>\n",
       "      <td>0.023668</td>\n",
       "      <td>0.022414</td>\n",
       "      <td>101.444832</td>\n",
       "      <td>0.397949</td>\n",
       "      <td>0.040447</td>\n",
       "      <td>0.024414</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.669625</td>\n",
       "      <td>0.026036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>1</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.0000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.00000</td>\n",
       "      <td>...</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>156.000000</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>1105.000000</td>\n",
       "      <td>53740.0</td>\n",
       "      <td>90.000000</td>\n",
       "      <td>90.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 519 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        feature    chroma_cens  chroma_cens.1  chroma_cens.2  chroma_cens.3  \\\n",
       "count    106577  106576.000000    106576.0000  106576.000000  106576.000000   \n",
       "unique   106577  104376.000000    104381.0000  104389.000000  104394.000000   \n",
       "top      114901       2.120035        -0.1481       0.687363       1.388522   \n",
       "freq          1      90.000000        90.0000      90.000000      90.000000   \n",
       "\n",
       "        chroma_cens.4  chroma_cens.5  chroma_cens.6  chroma_cens.7  \\\n",
       "count   106576.000000  106576.000000  106576.000000  106576.000000   \n",
       "unique  104409.000000  104378.000000  104389.000000  104383.000000   \n",
       "top         -0.779828      -1.049356      -1.352663      -1.146229   \n",
       "freq        90.000000      90.000000      90.000000      90.000000   \n",
       "\n",
       "        chroma_cens.8      ...           tonnetz.39     tonnetz.40  \\\n",
       "count    106576.00000      ...        106576.000000  106576.000000   \n",
       "unique   104374.00000      ...        104170.000000  103962.000000   \n",
       "top           0.13384      ...             0.115733       0.023668   \n",
       "freq         90.00000      ...            90.000000      90.000000   \n",
       "\n",
       "           tonnetz.41            zcr          zcr.1          zcr.2  \\\n",
       "count   106576.000000  106576.000000  106576.000000  106576.000000   \n",
       "unique  103954.000000  104379.000000    2583.000000  104218.000000   \n",
       "top          0.022414     101.444832       0.397949       0.040447   \n",
       "freq        90.000000      90.000000     156.000000      90.000000   \n",
       "\n",
       "                zcr.3     zcr.4          zcr.5          zcr.6  \n",
       "count   106576.000000  106576.0  106576.000000  106576.000000  \n",
       "unique    1153.000000     214.0  104320.000000  104272.000000  \n",
       "top          0.024414       0.0       5.669625       0.026036  \n",
       "freq      1105.000000   53740.0      90.000000      90.000000  \n",
       "\n",
       "[4 rows x 519 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "features.describe(include='all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0', 'echonest', 'echonest.1', 'echonest.2', 'echonest.3',\n",
       "       'echonest.4', 'echonest.5', 'echonest.6', 'echonest.7', 'echonest.8',\n",
       "       ...\n",
       "       'echonest.239', 'echonest.240', 'echonest.241', 'echonest.242',\n",
       "       'echonest.243', 'echonest.244', 'echonest.245', 'echonest.246',\n",
       "       'echonest.247', 'echonest.248'],\n",
       "      dtype='object', length=250)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#echonest\n",
    "echonest.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>echonest</th>\n",
       "      <th>echonest.1</th>\n",
       "      <th>echonest.2</th>\n",
       "      <th>echonest.3</th>\n",
       "      <th>echonest.4</th>\n",
       "      <th>echonest.5</th>\n",
       "      <th>echonest.6</th>\n",
       "      <th>echonest.7</th>\n",
       "      <th>echonest.8</th>\n",
       "      <th>...</th>\n",
       "      <th>echonest.239</th>\n",
       "      <th>echonest.240</th>\n",
       "      <th>echonest.241</th>\n",
       "      <th>echonest.242</th>\n",
       "      <th>echonest.243</th>\n",
       "      <th>echonest.244</th>\n",
       "      <th>echonest.245</th>\n",
       "      <th>echonest.246</th>\n",
       "      <th>echonest.247</th>\n",
       "      <th>echonest.248</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>audio_features</td>\n",
       "      <td>metadata</td>\n",
       "      <td>...</td>\n",
       "      <td>temporal_features</td>\n",
       "      <td>temporal_features</td>\n",
       "      <td>temporal_features</td>\n",
       "      <td>temporal_features</td>\n",
       "      <td>temporal_features</td>\n",
       "      <td>temporal_features</td>\n",
       "      <td>temporal_features</td>\n",
       "      <td>temporal_features</td>\n",
       "      <td>temporal_features</td>\n",
       "      <td>temporal_features</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>acousticness</td>\n",
       "      <td>danceability</td>\n",
       "      <td>energy</td>\n",
       "      <td>instrumentalness</td>\n",
       "      <td>liveness</td>\n",
       "      <td>speechiness</td>\n",
       "      <td>tempo</td>\n",
       "      <td>valence</td>\n",
       "      <td>album_date</td>\n",
       "      <td>...</td>\n",
       "      <td>214</td>\n",
       "      <td>215</td>\n",
       "      <td>216</td>\n",
       "      <td>217</td>\n",
       "      <td>218</td>\n",
       "      <td>219</td>\n",
       "      <td>220</td>\n",
       "      <td>221</td>\n",
       "      <td>222</td>\n",
       "      <td>223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>track_id</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>0.4166752327</td>\n",
       "      <td>0.6758939853</td>\n",
       "      <td>0.6344762684</td>\n",
       "      <td>0.0106280683</td>\n",
       "      <td>0.1776465712</td>\n",
       "      <td>0.1593100648</td>\n",
       "      <td>165.9220000000</td>\n",
       "      <td>0.5766609880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.9923025370</td>\n",
       "      <td>6.8056936264</td>\n",
       "      <td>0.2330697626</td>\n",
       "      <td>0.1928800046</td>\n",
       "      <td>0.0274549890</td>\n",
       "      <td>0.0640799999</td>\n",
       "      <td>3.6769599915</td>\n",
       "      <td>3.6128799915</td>\n",
       "      <td>13.3166904449</td>\n",
       "      <td>262.9297485352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>0.3744077685</td>\n",
       "      <td>0.5286430621</td>\n",
       "      <td>0.8174611317</td>\n",
       "      <td>0.0018511032</td>\n",
       "      <td>0.1058799438</td>\n",
       "      <td>0.4618181276</td>\n",
       "      <td>126.9570000000</td>\n",
       "      <td>0.2692402421</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.5823311806</td>\n",
       "      <td>8.8893079758</td>\n",
       "      <td>0.2584637702</td>\n",
       "      <td>0.2209050059</td>\n",
       "      <td>0.0813684240</td>\n",
       "      <td>0.0641300008</td>\n",
       "      <td>6.0827698708</td>\n",
       "      <td>6.0186400414</td>\n",
       "      <td>16.6735477448</td>\n",
       "      <td>325.5810852051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>0.0435668989</td>\n",
       "      <td>0.7455658702</td>\n",
       "      <td>0.7014699916</td>\n",
       "      <td>0.0006967990</td>\n",
       "      <td>0.3731433124</td>\n",
       "      <td>0.1245953419</td>\n",
       "      <td>100.2600000000</td>\n",
       "      <td>0.6216612236</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-2.2883579731</td>\n",
       "      <td>11.5271091461</td>\n",
       "      <td>0.2568213642</td>\n",
       "      <td>0.2378199995</td>\n",
       "      <td>0.0601223968</td>\n",
       "      <td>0.0601399988</td>\n",
       "      <td>5.9264898300</td>\n",
       "      <td>5.8663496971</td>\n",
       "      <td>16.0138492584</td>\n",
       "      <td>356.7557373047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>10</td>\n",
       "      <td>0.9516699648</td>\n",
       "      <td>0.6581786543</td>\n",
       "      <td>0.9245251615</td>\n",
       "      <td>0.9654270154</td>\n",
       "      <td>0.1154738842</td>\n",
       "      <td>0.0329852191</td>\n",
       "      <td>111.5620000000</td>\n",
       "      <td>0.9635898919</td>\n",
       "      <td>2008-03-11</td>\n",
       "      <td>...</td>\n",
       "      <td>-3.6629877090</td>\n",
       "      <td>21.5082283020</td>\n",
       "      <td>0.2833518982</td>\n",
       "      <td>0.2670699954</td>\n",
       "      <td>0.1257044971</td>\n",
       "      <td>0.0808200017</td>\n",
       "      <td>8.4140100479</td>\n",
       "      <td>8.3331899643</td>\n",
       "      <td>21.3170642853</td>\n",
       "      <td>483.4038085938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>134</td>\n",
       "      <td>0.4522173071</td>\n",
       "      <td>0.5132380502</td>\n",
       "      <td>0.5604099311</td>\n",
       "      <td>0.0194426943</td>\n",
       "      <td>0.0965666940</td>\n",
       "      <td>0.5255193792</td>\n",
       "      <td>114.2900000000</td>\n",
       "      <td>0.8940722715</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.4526963234</td>\n",
       "      <td>2.3563981056</td>\n",
       "      <td>0.2346863896</td>\n",
       "      <td>0.1995500028</td>\n",
       "      <td>0.1493317783</td>\n",
       "      <td>0.0644000024</td>\n",
       "      <td>11.2670698166</td>\n",
       "      <td>11.2026700974</td>\n",
       "      <td>26.4541797638</td>\n",
       "      <td>751.1477050781</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 250 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Unnamed: 0        echonest      echonest.1      echonest.2  \\\n",
       "0        NaN  audio_features  audio_features  audio_features   \n",
       "1        NaN    acousticness    danceability          energy   \n",
       "2   track_id             NaN             NaN             NaN   \n",
       "3          2    0.4166752327    0.6758939853    0.6344762684   \n",
       "4          3    0.3744077685    0.5286430621    0.8174611317   \n",
       "5          5    0.0435668989    0.7455658702    0.7014699916   \n",
       "6         10    0.9516699648    0.6581786543    0.9245251615   \n",
       "7        134    0.4522173071    0.5132380502    0.5604099311   \n",
       "\n",
       "         echonest.3      echonest.4      echonest.5      echonest.6  \\\n",
       "0    audio_features  audio_features  audio_features  audio_features   \n",
       "1  instrumentalness        liveness     speechiness           tempo   \n",
       "2               NaN             NaN             NaN             NaN   \n",
       "3      0.0106280683    0.1776465712    0.1593100648  165.9220000000   \n",
       "4      0.0018511032    0.1058799438    0.4618181276  126.9570000000   \n",
       "5      0.0006967990    0.3731433124    0.1245953419  100.2600000000   \n",
       "6      0.9654270154    0.1154738842    0.0329852191  111.5620000000   \n",
       "7      0.0194426943    0.0965666940    0.5255193792  114.2900000000   \n",
       "\n",
       "       echonest.7  echonest.8        ...               echonest.239  \\\n",
       "0  audio_features    metadata        ...          temporal_features   \n",
       "1         valence  album_date        ...                        214   \n",
       "2             NaN         NaN        ...                        NaN   \n",
       "3    0.5766609880         NaN        ...              -1.9923025370   \n",
       "4    0.2692402421         NaN        ...              -1.5823311806   \n",
       "5    0.6216612236         NaN        ...              -2.2883579731   \n",
       "6    0.9635898919  2008-03-11        ...              -3.6629877090   \n",
       "7    0.8940722715         NaN        ...              -1.4526963234   \n",
       "\n",
       "        echonest.240       echonest.241       echonest.242       echonest.243  \\\n",
       "0  temporal_features  temporal_features  temporal_features  temporal_features   \n",
       "1                215                216                217                218   \n",
       "2                NaN                NaN                NaN                NaN   \n",
       "3       6.8056936264       0.2330697626       0.1928800046       0.0274549890   \n",
       "4       8.8893079758       0.2584637702       0.2209050059       0.0813684240   \n",
       "5      11.5271091461       0.2568213642       0.2378199995       0.0601223968   \n",
       "6      21.5082283020       0.2833518982       0.2670699954       0.1257044971   \n",
       "7       2.3563981056       0.2346863896       0.1995500028       0.1493317783   \n",
       "\n",
       "        echonest.244       echonest.245       echonest.246       echonest.247  \\\n",
       "0  temporal_features  temporal_features  temporal_features  temporal_features   \n",
       "1                219                220                221                222   \n",
       "2                NaN                NaN                NaN                NaN   \n",
       "3       0.0640799999       3.6769599915       3.6128799915      13.3166904449   \n",
       "4       0.0641300008       6.0827698708       6.0186400414      16.6735477448   \n",
       "5       0.0601399988       5.9264898300       5.8663496971      16.0138492584   \n",
       "6       0.0808200017       8.4140100479       8.3331899643      21.3170642853   \n",
       "7       0.0644000024      11.2670698166      11.2026700974      26.4541797638   \n",
       "\n",
       "        echonest.248  \n",
       "0  temporal_features  \n",
       "1                223  \n",
       "2                NaN  \n",
       "3     262.9297485352  \n",
       "4     325.5810852051  \n",
       "5     356.7557373047  \n",
       "6     483.4038085938  \n",
       "7     751.1477050781  \n",
       "\n",
       "[8 rows x 250 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "echonest.head(8)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 13132 entries, 0 to 13131\n",
      "Columns: 250 entries, Unnamed: 0 to echonest.248\n",
      "dtypes: object(250)\n",
      "memory usage: 25.0+ MB\n"
     ]
    }
   ],
   "source": [
    "echonest.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>echonest</th>\n",
       "      <th>echonest.1</th>\n",
       "      <th>echonest.2</th>\n",
       "      <th>echonest.3</th>\n",
       "      <th>echonest.4</th>\n",
       "      <th>echonest.5</th>\n",
       "      <th>echonest.6</th>\n",
       "      <th>echonest.7</th>\n",
       "      <th>echonest.8</th>\n",
       "      <th>...</th>\n",
       "      <th>echonest.239</th>\n",
       "      <th>echonest.240</th>\n",
       "      <th>echonest.241</th>\n",
       "      <th>echonest.242</th>\n",
       "      <th>echonest.243</th>\n",
       "      <th>echonest.244</th>\n",
       "      <th>echonest.245</th>\n",
       "      <th>echonest.246</th>\n",
       "      <th>echonest.247</th>\n",
       "      <th>echonest.248</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>13130</td>\n",
       "      <td>13131.000000</td>\n",
       "      <td>13131</td>\n",
       "      <td>13131</td>\n",
       "      <td>13131.00000</td>\n",
       "      <td>13131</td>\n",
       "      <td>13131</td>\n",
       "      <td>13131.00</td>\n",
       "      <td>13131.00000</td>\n",
       "      <td>2719</td>\n",
       "      <td>...</td>\n",
       "      <td>13131.000000</td>\n",
       "      <td>13131</td>\n",
       "      <td>13131.000000</td>\n",
       "      <td>13131.0000</td>\n",
       "      <td>13131.000000</td>\n",
       "      <td>13131.0000</td>\n",
       "      <td>13131.00000</td>\n",
       "      <td>13131.00000</td>\n",
       "      <td>13131.000000</td>\n",
       "      <td>13131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>13130</td>\n",
       "      <td>12912.000000</td>\n",
       "      <td>13131</td>\n",
       "      <td>13131</td>\n",
       "      <td>12990.00000</td>\n",
       "      <td>13131</td>\n",
       "      <td>13131</td>\n",
       "      <td>12314.00</td>\n",
       "      <td>13129.00000</td>\n",
       "      <td>444</td>\n",
       "      <td>...</td>\n",
       "      <td>13130.000000</td>\n",
       "      <td>13130</td>\n",
       "      <td>13126.000000</td>\n",
       "      <td>8929.0000</td>\n",
       "      <td>13130.000000</td>\n",
       "      <td>1478.0000</td>\n",
       "      <td>12755.00000</td>\n",
       "      <td>12991.00000</td>\n",
       "      <td>13131.000000</td>\n",
       "      <td>13131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>32760</td>\n",
       "      <td>0.995796</td>\n",
       "      <td>0.5429413172</td>\n",
       "      <td>0.3249142017</td>\n",
       "      <td>0.97287</td>\n",
       "      <td>0.1087110744</td>\n",
       "      <td>0.5752967282</td>\n",
       "      <td>100.01</td>\n",
       "      <td>0.99999</td>\n",
       "      <td>2008</td>\n",
       "      <td>...</td>\n",
       "      <td>-1.761692</td>\n",
       "      <td>11.0926570892</td>\n",
       "      <td>0.289836</td>\n",
       "      <td>0.2322</td>\n",
       "      <td>0.020196</td>\n",
       "      <td>0.0639</td>\n",
       "      <td>2.11279</td>\n",
       "      <td>2.20122</td>\n",
       "      <td>3.544959</td>\n",
       "      <td>9.7418966293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>1</td>\n",
       "      <td>195.000000</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>38.00000</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6.00</td>\n",
       "      <td>3.00000</td>\n",
       "      <td>89</td>\n",
       "      <td>...</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>109.0000</td>\n",
       "      <td>3.00000</td>\n",
       "      <td>2.00000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 250 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0      echonest    echonest.1    echonest.2   echonest.3  \\\n",
       "count        13130  13131.000000         13131         13131  13131.00000   \n",
       "unique       13130  12912.000000         13131         13131  12990.00000   \n",
       "top          32760      0.995796  0.5429413172  0.3249142017      0.97287   \n",
       "freq             1    195.000000             1             1     38.00000   \n",
       "\n",
       "          echonest.4    echonest.5  echonest.6   echonest.7 echonest.8  \\\n",
       "count          13131         13131    13131.00  13131.00000       2719   \n",
       "unique         13131         13131    12314.00  13129.00000        444   \n",
       "top     0.1087110744  0.5752967282      100.01      0.99999       2008   \n",
       "freq               1             1        6.00      3.00000         89   \n",
       "\n",
       "            ...       echonest.239   echonest.240  echonest.241  echonest.242  \\\n",
       "count       ...       13131.000000          13131  13131.000000    13131.0000   \n",
       "unique      ...       13130.000000          13130  13126.000000     8929.0000   \n",
       "top         ...          -1.761692  11.0926570892      0.289836        0.2322   \n",
       "freq        ...           2.000000              2      2.000000       12.0000   \n",
       "\n",
       "        echonest.243 echonest.244  echonest.245  echonest.246  echonest.247  \\\n",
       "count   13131.000000   13131.0000   13131.00000   13131.00000  13131.000000   \n",
       "unique  13130.000000    1478.0000   12755.00000   12991.00000  13131.000000   \n",
       "top         0.020196       0.0639       2.11279       2.20122      3.544959   \n",
       "freq        2.000000     109.0000       3.00000       2.00000      1.000000   \n",
       "\n",
       "        echonest.248  \n",
       "count          13131  \n",
       "unique         13131  \n",
       "top     9.7418966293  \n",
       "freq               1  \n",
       "\n",
       "[4 rows x 250 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "echonest.describe(include='all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}
